Qid Examcode Question Qimpath opt1 opt2 opt3 opt4 opt5 opt6 opt7 opt8 opt9 opt10 opt11 opt12 opt13 opt14 opt15 impath1 impath2 impath3 impath4 impath5 impath6 impath7 impath8 impath9 impath10 impath11 impath12 impath13 impath14 impath15 answers uanswer CR Edit Delete
61 1Z0-070 Which two statements are true about Exadata storage server and database server alerts on an X5 Database Machine? Metric alerts are never stateful. Metric thresholds, if set, will persist across storage and database server reboots. SMTP alert notifications must be sent to both ASR manager and Enterprise Manager agents. SNMP alert notifications can be sent to only one destination. Metrics have no thresholds set on them by default. 2, 3 MC edit delete
60 1Z0-070 You plan to migrate a very large database supporting a DSS workload to your new X5 Database Machine. It will be the only database on this full rack. Which three statements are true about Database Machine features that improve performance for the DSS workload? Smart Storage operations can improve the performance of joins. Smart Storage operations can improve the performance of scans. Hybrid Columnar Decompression overheads can be offloaded from the database servers for index full scans. Full table scan operations can improve due to the default Smart Flash Cache implementation. Hybrid Columnar Compression can reduce the amount of physical I/O required to scan large tables. 2, 3, 4 MC edit delete
59 1Z0-070 A heap-organized table in one of your database schemas contains only date, char, varchar2, and number data type columns. Which three operations can be offloaded to Exadata Storage Servers when performing a Smart Scan on this table? Column filtering MIN/MAX scans Virtual column filtering Nested loop join filtering Sort-merge join filtering Predicate filtering 1, 3, 6 MC edit delete
58 1Z0-070 Which two statements are true about Exadata X5 cell metrics and alerts? Cell alerts on each storage server are accumulated in memory by the CELLSRV process and stored on a filesystem-based repository. Cell metrics are written to disk every hour by default. Cell metrics on each storage server are accumulated in memory by the CELLSRV process and written to a filesystem-based repository. Cell alerts on each server are accumulated in memory by the MS process and stored on a filesystem-based repository. Cell alerts are written to disk every hour by default. 2, 4 MC edit delete
57 1Z0-070 Which three statements are true about the EXADCLI utility? It may be run interactively. It can be used to execute EXACLI scripts on multiple storage servers in parallel. It can be used to execute O/S commands on multiple storage servers in parallel. It can be used to execute EXACLI commands on multiple storage servers in parallel. It uses the same security mechanism as the EXACLI command. It may be used to execute DBMCLI commands on multiple database nodes in parallel. 4, 5, 6 MC edit delete
56 1Z0-070 Which two options should be used to identify a damaged or failing flash card on an X6 Database Machine high-capacity storage server? Using the CELLCLI CALIBRATE command on the storage server after logging in as the root user Using the CELLCLI LIST LUN DETAIL command as the celladmin user Using the CELLCLI CALIBRATE command on the storage server after logging in as the celladmin user Hardware monitoring using the storage server ILOM 1, 4 MC edit delete
55 1Z0-070 A file contains a script with several EXACLI commands that must be executed on each cell in an X5 full rack. The script must run on each cell simultaneously. How would you achieve this? Copy the script to all cells using the DCLI command and manually execute it on each cell using the DCLI command. Copy the script to the cells using the EXACLI command and execute the script on all cells using the EXACLI command. Execute it on all cells using the EXADCLI command specifying the file name containing the EXACLI script. Copy the script to all cells using the CELLCLI command and execute it on all cells in parallel using the CELLCLI command. Execute it on all cells using the DBMCLI command specifying the file name containing the EXACLI script. 3 SC edit delete
54 1Z0-070 Which three must be true for a Smart Scan to occur for a table? cell_offload_processing must be true in sessions issuing SQL statements that access the table. The query must be executed serially. The query must be executed in parallel. Direct path reads must be used at run time. The ASM diskgroup containing the table’s tablespace must have a 4 Mbyte AU size. The ASM diskgroup containing the table’s tablespace must have cell.smart_scan_capable set to true. 1, 4, 6 MC edit delete
53 1Z0-070 Which two must be true for a Smart Scan to occur on a table? Sessions querying the table must set cell_offload_processing = true. It must be stored in an ASM diskgroup with a 4 MByte AU size. It must be heap organized. It must be accessed using direct path reads. The table must not be compressed. 1, 4 MC edit delete
52 1Z0-070 Which four are true about Exadata features? Storage Indexes persist across Exadata storage server reboots. Data Warehouse workloads will benefit from Smart Flash Cache configured in Write-Through mode. Hybrid Columnar Compressed tables can be compressed and decompressed on Exadata storage servers. Hybrid Columnar Compressed tables can be compressed and decompressed on the database servers. OLTP workloads will benefit from Smart Flash Cache configured in Write-Back mode. Storage Indexes persist across database server reboots. 3, 4, 5, 6 MC edit delete
51 1Z0-070 You issued these commands to all Exadata Storage Servers in an X6 Exadata Database Machine using dcli: 51-qexdata.png alter iormplan objective=high_throughput alter iormplan objective=balanced alter iormplan objective=low_latency alter iormplan objective=auto alter iormplan objective=‘ ’ 4 SC edit delete
50 1Z0-070 Which three are true concerning Storage Indexes? A maximum of eight table columns for any table are indexed per storage region. The use of Storage Indexes for particular categories of I/O can be displayed by using an I/O Resource Manager Category Plan. Storage Indexes persist across any Exadata storage server reboots. The use of Storage Indexes for a particular database can be disabled by using an I/O Resource Manager Database Plan. A Storage Index is automatically maintained by CELLSRV based on the filter columns of the offloaded SQL. Different storage regions may have different columns indexed for the same table. 1, 4, 5 MC edit delete
49 1Z0-070 Which three are sources for alerts from storage servers in an X5 Database Machine? Software errors reported by the MS process on the storage servers Hardware sensor alerts reported by the CELLSRV process on the storage servers Software errors reported by the RS process on the storage servers Hardware sensor alerts detected by the ILOM on the storage servers Metrics that have administrator-defined thresholds on the storage servers 1, 2, 5 MC edit delete
48 1Z0-070 Which two statements are true about the Integrated Lights Out Manager (ILOM) on an Exadata X5 or X6 Database Machine? ILOM on database servers can use IPMI to send sensor alerts to an Enterprise Manager Agent. ILOM on a storage server uses SNMP to send sensor alerts to the cellsrv process on the same storage server. ILOM on a storage server uses IPMI to send sensor alerts to the MS process on the same storage server. ILOM on a storage server uses SNMP to send sensor alerts to the MS process on the same storage server. ILOM on database servers can use SNMP to send sensor alerts to an Enterprise Manager Agent. 3, 5 MC edit delete
47 1Z0-070 You must apply patches and patch bundles in a rolling fashion, if possible, on the components of your Exadata X6 Database Machine. Instructions for patching the Grid Infrastructure home on the primary location Instructions for patching the Data Guard environment on the standby location Instructions for patching the RAC Oracle Home on the primary location Instructions for patching only storage servers Instructions for patching all components on the Database Machine 1, 3 MC edit delete
46 1Z0-070 You plan to consolidate your company’s INVENTORY and SALES databases onto your new Exadata X6 Database Machine. You are considering consolidation of all schemas into one RAC database. Which three factors would you need to consider before choosing this approach? the number of database users Security Policies the number of database roles the number of simultaneous sessions the maintenance schedule 1, 2, 4 MC edit delete
45 1Z0-070 You are evaluating the performance of a SQL statement that accesses a very large table. 45-qexdata.png There is an index on the column used in the WHERE clause, causing “cell multiblock physical reads” to be requested by the database instance, resulting in additional I/O. The table is an IOT and has an overflow segment, causing “cell multiblock physical reads” to be requested by the database instance, resulting in additional I/O. There is an uncommitted transaction that has modified some of the table blocks, causing some “cell single block physical reads” to be requested by the database instance, resulting in additional I/O. The table is an index clustered table, causing “cell single block physical reads” to be requested by the database instance, resulting in additional I/O. There are migrated rows in the table, causing some “cell single block physical reads” to be requested by the database instance, resulting in additional I/O. 2, 5 MC edit delete
44 1Z0-070 Which two activities are supported on the storage servers in an Exadata X6 Database Machine? Upgrading the Storage Server software package using RPM Configuring secure shell user equivalency for the cellmonitor user Installing an alternative package manager Changing the root password Upgrading a device driver for hard disks when inserting a replacement disk after a hard disk failure 1, 3 MC edit delete
43 1Z0-070 Examine this IORM plan: 43-qexdata.png The Finance database can use at least 45%, but never more than 60%, of the total Flash Cache capacity. I/Os from the finance database are guaranteed to get a minimum of 45% of the I/O bandwidth if the demand exists, and a maximum of 60% of the I/O bandwidth even if no other databases are doing I/O to the cell, and the demand from the finance database exceeds 60% of the maximum I/O rate of the cell. If I/Os come from the HR database only, then they may get up to 100% of the I/O bandwidth on the cell. I/Os from the finance database are guaranteed to get 45% of the I/O bandwidth if the demand is at least 60% of the maximum I/O rate of the cell, but may get 100% of the I/O bandwidth if no other databases are performing I/O to the cell. If I/Os come from the HR database only, then they may get up to 10% of the I/O bandwidth on the cell. 2, 5 MC edit delete
42 1Z0-070 You are examining your Exadata storage servers for routine maintenance requirements and run the imageinfo command as shown: 42-qexdata.png /dev/md6 and /dev/md8 have one of their mirror copies on physicaldisk 1 /dev/md6 and /dev/md8 are located only on physicaldisk 1 /dev/md5 and /dev/md7 have one of their mirror copies on physicaldisk 0 /dev/md5 and /dev/md7 are located only on physicaldisk 0 2, 3 MC edit delete
41 1Z0-070 Which three statements are true about bulk data loading capabilities in an X5 Database Machine environment? DBFS must use the DBFS_DG diskgroup for any DBFS store. DBFS may be used if Exadata-based shared storage is required to stage data before bulk loading into a database. DBFS must be used to have a POSIX-compliant shared storage solution that is accessible from the database servers on a Database Machine. DBFS must be used to bulk load data into a production database on the Database Machine. ACFS may be used if Exadata-based shared storage is required to stage data before bulk loading into a database. ACFS must be used to have a POSIX–compliant shared storage solution that is accessible from the database servers on a Database Machine. ACFS may use the DBFS_DG diskgroup to contain the ADVM volume file. 2, 3, 4 MC edit delete
40 1Z0-070 Identify three valid configuration options that can be implemented during the initial configuration process of a new X5 Database Machine by using the Exadata Deployment Assistant. Virtualized Compute Node configuration OS users that own the Grid Infrastructure installation Cluster configuration for up to 32 clusters The size for the system area on the first two disks in each cell Virtualized Storage node configuration 1, 3, 4 MC edit delete
39 1Z0-070 Which three statements are true about Recovery Manager (RMAN) daily differential incremental backup strategies on an X5 Database Machine for a database having 25% or more of its blocks modified each day and which has an 8 k block size? Fast incremental backups when 50% or more of the blocks have changed since the last backup, will run as slowly as normal incremental backup. Enabling Block Change Tracking (BCT) on the database can result in reduced consumption of storage network bandwidth. Enabling Block Change Tracking (BCT) on the database can result in a reduction of physical I/O on the cells during incremental backups. For level-1 backups, Block Change Tracking (BCT) is most beneficial when more than 25 percent of the blocks have changed since the last backup. For level-0 backups, Block Change Tracking (BCT) is most beneficial when more than 25 percent of the blocks have changed since the last backup. cellsrv returns only blocks that have changed since the last backup. 1, 3, 6 MC edit delete
38 1Z0-070 Which three are true concerning Hybrid Columnar Compression (HCC) deployed on Exadata storage? HCC can be used only when the Exadata Smart Flash Cache is configured in Write-Through mode. HCC data is never cached in the Exadata Smart Flash Cache. By default, decompression is performed by Exadata Storage Servers. Rows residing in HCC compressed segments, are always self- contained in a single database block. Rows residing in HCC compressed segments, are always self- contained in a single compression unit. Row-level locks are supported on HCC compressed data. 3, 5, 6 MC edit delete
37 1Z0-070 Which three are recommended options on an X5 Exadata Database machine, for staging files that will be loaded as external tables? on an ACFS file system stored in a staging database on the Database Machine a ZFS over NFS file system mounted on a database server where the external table will be accessed an Exadata-based ACFS file system on the Database Machine a DBFS file system stored in a staging database on the Database Machine on local storage on one or more storage servers that are accessible to the database server where the load will be performed 1, 2, 5 MC edit delete
36 1Z0-070 You plan to migrate an existing production database supporting online transaction processing (OLTP) workloads to an X6 Exadata Database Machine. The database currently supports an application requiring fast response times to satisfy stringent business requirements, and most of the application queries use indexed access to tables. For which two cases would you consider dropping indexes that are not used for constraints after the migration to assure that Smart Scans occur? if Smart Scan performs better that any type of index scan on the corresponding table. if Smart only occur instead of index skip scans on the corresponding table. if Smart only occur instead of index range scans on the corresponding table. if Smart Scans performs equally well to any type of index scan on the corresponding table. 1, 3 MC edit delete
35 1Z0-070 Which three are true concerning Smart Scans? The decision to perform a Smart Scan is made by the Optimizer. Smart Scans are only possible during full table scans or fast full index scans. Smart Scans are possible on Index Organized Tables (IOTs). Smart Scans always outperform scans that are not offloaded. Smart Scans are possible on heap organized tables. Smart Scans are possible on uncompressed B*Tree indexes. 1, 2, 6 MC edit delete
34 1Z0-070 You issued these commands to all Exadata Storage Servers in an X6 Exadata Database Machine using dcli: 34-qexdata.png alter iormplan objective = low_latency alter iormplan objective = high_throughput alter iormplan objective = balanced alter iormplan objective = auto 1 SC edit delete
33 1Z0-070 Because of a motherboard failure on an X6 high-capacity Exadata storage server, you must replace the server chassis with a replacement unit. Which are three of the components must you move from the original Exadata storage server to the new Exadata storage server? Redundant power supplies The host bus channel adaptor The USB flash drive The four Sun Flash Accelerator PCIe cards The 12 physical disks 1, 4, 5 MC edit delete
32 1Z0-070 Which three statements are true about the CELLCLI command? It can execute commands on multiple storage servers in parallel. It has command-line history. It requires root privileges to create CELLDISKS and GRIDDISKS. It can be executed on storage servers. It can be executed using the DCLI utility. 2, 4, 5 MC edit delete
31 1Z0-070 Identify two valid reasons for executing an X5 Exadata storage server rescue procedure. Accidental loss of all data from all griddisks in a storage server Corruption in the /(root) filesystem Corruption in a normal or high redundancy ASM diskgroup The failure of both physical disks 0 and 1 Only the failure of physical disk 1 Only the failure of physical disk 0 2, 4 MC edit delete
30 1Z0-070 Which two are benefits of an active/inactive configured InfiniBand network on Exadata Database Machine X5? Improved performance for Oracle Network traffic Improved reliability for Cache Fusion RAC network traffic Improved reliability when executing Distributed Command Line Interface (DCLI) to run CELLCLI commands Improved performance for ASM rebalance network traffic Improved performance when executing Distributed Command Line Interface (DCLI) to run CELLCLI commands 2, 3 MC edit delete
29 1Z0-070 Which two statements are true about the Enterprise Manager plug-in configuration for the X5 Database Machine? There is one plug-in for Cloud Control. There are several separate plug-ins for Cloud Control. Some components of the Database Machine require SNMP trap forwarders. All components of the Database Machine require SNMP trap forwarders. 1, 3 MC edit delete
28 1Z0-070 You must replace the battery on the disk controller in three Exadata storage servers and must power off the affected storage servers. Which two commands must you execute to safely power off the storage servers in an X5 Database Machine? ‘shutdown -h now’ on the affected storage servers CellCLI> LIST GRIDDISK WHERE STATUS != ‘inactive’ CellCLI > LIST GRIDDISK ATTRIBUTES name WHERE asmdeactivationoutcome != ‘Yes’ ‘crsctl stop cluster –all’ on one of the database servers CellCLI> ALTER GRIDDISK ALL INACTIVE 3, 5 MC edit delete
27 1Z0-070 Which four statements are true about the configuration of Auto Service Request (ASR) for use with an X5 Database Machine? ASR Manager software may be installed on one of the database servers in the Database Machine. ASR can connect to the Internet using Simple Network Management Protocol (SNMP), using a proxy server. ASR Manager can connect to the Internet directly with HTTPS. ASR Manager can connect to the Internet with HTTPS using a proxy server. ASR can connect to the Internet directly using Simple Network Management Protocol (SNMP). ASR Manager software may be installed on a server that is not part of the Database Machine. 1, 3, 4, 6 MC edit delete
26 1Z0-070 You are patching your Exadata X6 Database Machine by applying a new image to the Storage Servers in a rolling fashion. 26-qexdata.png DBFS_DG DATA3_DBM1 DATA2_DBM1 DATA_DBM1 RECO_DBM1 4, 5 MC edit delete
25 1Z0-070 As part of planning for database consolidation, you grouped your databases into two categories based on different technical and business objectives. Which three statements are true about possible configurations for your Exadata X6 Database Machine fabric? The storage grid may be partitioned when deploying a single-rack Database Machine configuration using virtualization. The database grid may be partitioned when deploying a multirack Database Machine configuration. A single database cluster benefits from accessing multiple storage grids. Multiple database clusters may access the same storage grid. Multiple database clusters never benefit from accessing a single storage grid. 2, 3, 4 MC edit delete
24 1Z0-070 In which three situations will a Smart Scan occur on a table for which Smart Scan is possible, assuming that nothing in the environment prevents a Smart Scan? The ASM diskgroup containing the table’s tablespace has a 4 MByte AU size. Executing queries in parallel. setting _serial_direct_read= true in the session issuing the SQL statements and executing a serial query. Having direct path reads used at execution time. An update to the table is made identifying the row to be modified by primary key. An index range scan occurs for the table. 2, 3, 4 MC edit delete
23 1Z0-070 Which three are true concerning Exadata snapshot databases? They are supported on non-container databases. They are based on a read-write copy of an existing database. They are integrated with the Multitenant architecture. They can be created only on sparse ASM disk groups. They don’t support all Exadata features. They can be created on any type of ASM disk group. 1, 3, 4 MC edit delete
22 1Z0-070 Which two statements are true about the use of Intelligent Platform Management Interface (IPMI) on an X5 or X6 Database Machine? IPMI can be used for server configuration and management on each database server. The Baseboard Management Controller (BMC), which supports IPMI, runs as a multithreaded process on the storage server O/S. The Baseboard Management Controller (BMC), which supports IPMI, runs as a single-threaded process on the storage server O/S. IPMI can be used for server configuration and management on each storage server. 1, 3 MC edit delete
21 1Z0-070 Which two statements are true about data paths used during RMAN backup and restore operations when media management servers use InfiniBand to connect to an X5 Database Machine? During backups, data blocks are always read from Smart Flash Cache by cellsrv. During restores, data blocks read from the media are sent to a database server that sends the blocks to cellsrv to be written. During backups, data blocks are read by cellsrv and sent to a database server, which sends the blocks to the media manager to be written to media. During backups, data blocks are read by cellsrv and sent directly to the media manager to be written to media. During restores, data blocks read from the media are sent directly to cellsrv to be written. 4, 5 MC edit delete
20 1Z0-070 Which two statements are true about Auto Service Request (ASR) with an X5 Database Machine? ASR Manager must be installed and configured on a dedicated server external to the Database Machine. Configuring ASR is mandatory for all Database Machine assets. ASR Manager opens a service request (SR) automatically after sensors detect hardware faults ASR Manager must be installed and configured on one of the database servers. ASR can upload configuration metadata to support problem resolution. ASR communicates with Oracle support services using HTTPS. 1, 3 MC edit delete
19 1Z0-070 You are designing the monitoring architecture and procedures for an X5 Database Machine fabric consisting of two full racks, to provide for the monitoring for all components on the critical path of the admin network. Which two components need to be monitored? the Infiniband leaf switches the power distribution units the Cisco 48 port Catalyst Ethernet Switch the InfiniBand spine switches 3, 4 MC edit delete
18 1Z0-070 Identify two supported modifications to an X5 Database Machine. installing a Host Bus Adapter (HBA) in the compute nodes installing additional Operating System (O/S) packages on the compute nodes installing additional Operating System (O/S) packages on the Exadata storage servers installing a Host Bus Adapter (HBA) in the storage servers replacing the Cisco Ethernet switch with another make or model replacing the Infiniband switches with another make or model 2, 4 MC edit delete
17 1Z0-070 Which four statements are true concerning the configuration or use of Enterprise Manager Cloud Control to monitor and manage Exadata Database Machine components? Computer nodes forward their SNMP traps to the Management Server process on the same computer node. Storage nodes forward their SNMP traps to the Management Server process on the same storage node. Cloud control can monitor and manage a Database Machine compute node expansion rack. Oracle management agents must only be installed on one storage node in a Database Machine to enable monitoring and management of all storage nodes. Cloud Control cannot monitor partitioned Exadata Database Machine systems. Cloud Control can monitor and manage a Database Machine storage Expansion rack. Oracle management agents must only be installed on one compute node in a Database Machine to enable monitoring and management of all compute nodes and storage nodes. 2, 3, 6, 7 MC edit delete
16 1Z0-070 You plan to migrate an Oracle database that supports an online transaction processing (OLTP) workload to your X6 Database Machine. The Database Machine database version is 11.2. You plan to perform a physical database migration using Transportable Database. Which two are requirements for this method? The source database must be deployed on a Little Endian platform, The source database must be at least 11.1. The source database must be at least 11.2. The source database must use only bigfile tablespaces. The source database must be deployed on a Big Endian platform. The source database must not use bigfile tablespaces. 1, 3 MC edit delete
15 1Z0-070 You installed ASR Manager on a stand-alone server and configured Auto Service Request (ASR) for your X5 Database Machine and its assets. Which three statements are true about this configuration? Simple Network Management Protocol (SNMP) traps are used to send notifications from database servers to the ASR Manager. Simple Network Management Protocol (SNMP) traps are used to send notifications from storage servers to the ASR Manager. When a component fault occurs, fault telemetry is securely transmitted to Oracle via Simple Network Management Protocol (SNMP). When a component fault occurs, fault telemetry is securely transmitted to Oracle via HTTPS. Simple Network Management Protocol (SNMP) traps are used to send notifications from the Enterprise Manager to the ASR Manager. Simple Network Management Protocol (SNMP) traps received by ASR Manager are forwarded to the Enterprise Manager. 2, 3, 6 MC edit delete
14 1Z0-070 Which two are true about sparse griddisks and their use in disk groups on an X5 Exadata Database Machine? Sparse diskgroups must be created using sparse griddisks. Sparse diskgroups may be created using a combination of sparse and non-sparse griddisks. Sparse diskgroups may not be used for database snapshots. Additional space for a sparse griddisk is allocated as soon as newly written data is stored in the flashcache on a cell. The virtual size of a sparse griddisk may exceed the physical size of the space occupied by the griddisk. 1, 5 MC edit delete
13 1Z0-070 Which two statements are true about the use of DBFS, ACFS, and external file systems and components in an X5 Database Machine environment? ACFS uses storage in a database on the database machine DBFS supports file system snapshots. ACFS supports file system snapshots. Storage Area Network (SAN) –based file systems may be accessed directly from the storage servers in a database machine. Oracle Sun ZFS Storage Appliance-based files are not automatically protected by Data Guard. 2, 3 MC edit delete
12 1Z0-070 Which components of an Exadata storage server image, if updated, may require that a patch also be applied to the database servers in an Exadata X6 Database Machine? Linux operating system on the storage server InfiniBand HCA firmware on the storage server Storage server hard disk device drivers Storage server flash device drivers 4 SC edit delete
11 1Z0-070 Which three are true about Exadata Smart Flash Log? Databases on the Database Machine use Exadata Smart Flash Log by default. I/O Resource Manager database plans can be used to enable or disable Exadata Smart Flash Log for individual databases. LGWR will not wait for writes to Exadata Smart Flash Log if the write to a disk-based logfile completes first. I/O Resource Manager category plans can be used to enable or disable Exadata Smart Flash Log for different I/O categories. The use of Exadata Smart Flash Logs is mandatory for support of production databases. 1, 2, 3 MC edit delete
10 1Z0-070 You wish to determine if the I/O resource management plan that you created has helped improve the performance of OLTP category I/Os on your X6 Exadata Database Machine. 10-qexdata.png CT_IO_RQ_SM, CT_IO_RQ_LG, CT_IO_RQ_SM_SEC, and CT_IO_RQ_LG_SEC CT_IO_UTIL_SM and CT_IO_UTIL_LG CT_IO_RQ_SM_SEC and CT_IO_RQ_LG_SEC CT_IO_WT_SM, CT_IO_WT_LG, CT_IO_WT_SM_RQ, and CT_IO_WT_LG_RQ 4 SC edit delete
9 1Z0-070 You are evaluating the performance of a SQL statement that accesses a very large table. 09-qexdata.png There is a transaction, which committed after the query began, that has modified some of the table blocks, causing some “cell single block physical reads” to be requested by the database instance, resulting in additional I/O. There are chained rows in the table, causing some “cell single block physical reads” to be requested by the database instance, resulting in additional I/O. The table is a hash clustered table, causing “cell multiblock physical reads” to be requested by the database instance, resulting in additional I/O. The table is list partitioned, causing “cell list of blocks physical reads” to be requested by the database instance, resulting in additional I/O. There is a local index on a list partitioned table on the column used in the WHERE clause, causing “cell list of blocks physical reads” to be requested by the database instance, resulting in additional I/O. 3, 4 MC edit delete
8 1Z0-070 Which two are true concerning Columnar Flash Caching? It can be enabled or disabled for individual databases by using I/O Resource Manager database plans. It automatically transforms ROW STORE COMPRESS compressed data into a pure columnar format during Exadata Smart Flash Cache population. Data is either cached in Hybrid Columnar Compressed format or in pure compressed format, but never in both formats at the same time. It is enabled by default. It automatically transforms Hybrid Columnar Compressed (HCC) data into a pure columnar format during Exadata Smart Flash Cache population. It improves single-row lookup performance. 4, 5 MC edit delete
7 1Z0-070 Which two are true about Smart Scan? A query rewrite may occur to a materialized view stored in Exadata, and it will always benefit from Smart Scan. Column projection does not contribute to the performance benefit of Smart Scan. A query rewrite may occur to a materialized view stored in Exadata but will never benefit from Smart Scan. It is possible to offload single row functions to the Exadata Storage Servers. Join processing can be partly offloaded to Exadata Storage Servers. Join processing can be fully offloaded to Exadata Storage Servers. 4, 5 MC edit delete
6 1Z0-070 Which statement is true about operating systems in an X5 Database Machine multirack configuration consisting of two full racks and one Exadata storage expansion rack? All Exadata storage servers used by the same virtual cluster nodes must run the same O/S but Exadata Storage Servers in different clusters may run different operating systems. All Exadata storage servers must run the Oracle Solaris O/S and all database servers within the same cluster must run Oracle Linux. All Exadata storage servers may run Oracle Virtual Machine (OVM). All Exadata storage servers must run Oracle Linux. All Exadata storage servers must run the Oracle Linux O/S and all database servers within the same cluster must run the same version of Oracle Virtual Machine (OVM). 4 SC edit delete
5 1Z0-070 Which two completely prevent a Smart Scan from occurring? querying a table containing many chained rows querying a table containing many migrated rows performing a minimum or maximum function on an indexed column performing a Fast Full Index scan on a reverse key index referencing more than 255 columns form an OLTP compressed table in a query querying a table containing a JSON column 2, 5 MC edit delete
4 1Z0-070 An Exadata storage server physical disk on an X5 high-capacity full rack entered the predictive failure state. Identify the two steps that you must perform to replace this failed physical disk. Add the griddisks back into the ASM diskgroup they used to be a member of. Create a new celldisk and new griddisks on the replaced physical disk. Verify that the griddisks located on the physical disk have been successfully dropped from the associated ASM diskgroups. Identify the griddisks located on the failed physical disk and drop them from the associated ASM diskgroups. Replace the failed physical disk. 3, 5 MC edit delete
3 1Z0-070 You are planning your deployment of Enterprise Manager to monitor all the components of an X5 Database Machine. 03-qexdata.png Database Machine plug-ins must be deployed to at least two Enterprise Manager agents. Fail back to the original agent when the host is restarted is done automatically. Fail over to any secondary agent is done automatically. Fail over to any secondary agent must be done manually. Database machine plug-ins must be deployed to all Enterprise Manager agents. Fail back to the original agent when the host is restarted must be done manually. 2, 3, 5 MC edit delete
2 1Z0-070 You plan to monitor the ASM configuration on an X5 Database Machine as part of your role supporting Exadata-based ASM diskgroups. You want to check for potential space problems that take ASM mirroring requirements into account. Which two values would you monitor from V$ASM_DISKGROUP or by using the ASMCMD LSDG command? cold_used_mb total_mb required_mirror_free_mb free_mb usable_file_mb 2, 4 MC edit delete
1 1Z0-070 Which three storage components are available after nonvirtualized standard deployment of an X5 Database Machine using high-capacity disks? mirrored system area on hard disk 0, hard disk 1, and hard disk 2 Exadata Smart Flash Cache using all of the flashdisk space the DBFS_DG diskgroup with high redundancy mirrored system area on hard disk 0 and hard disk 1 the RECO_ ASM diskgroup the DATA_ ASM diskgroup 3, 4, 6 MC edit delete

Copyright © Designed & Developed by Sakthi Db Technology 2018